package com.initial.mapper;

import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.initial.entity.TbCrmCustomer;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * @author 余小年
 * @description 针对表【tb_crm_customer】的数据库操作Mapper
 * @createDate 2021-12-14 17:22:00
 * @Entity com.initial.entity.TbCrmCustomer
 */
public interface TbCrmCustomerMapper extends BaseMapper<TbCrmCustomer> {
    //展示和模糊查询
    IPage<TbCrmCustomer> selectCustomer(@Param("lname") String lname, @Param("addr") String addr, @Param("time") String time, @Param("industry") String industry, Page<TbCrmCustomer> page);

    //查看
    TbCrmCustomer selectCustomerById(Integer id);

    TbCrmCustomer selectById(Integer id);

//    int updateCustomerById(@Param("com.initial.entity.TbCrmCustomer") TbCrmCustomer tbCrmCustomer,@Param("id") Integer id);

   /* IPage<TbCrmCustomer> todayCreate(@Param("type") String type, Page<TbCrmCustomer> page);
    IPage<TbCrmCustomer> weekCreate(@Param("type") String type, Page<TbCrmCustomer> page);
    IPage<TbCrmCustomer> monthCreate(@Param("type") String type, Page<TbCrmCustomer> page);*/

    //本日、本周、本月新建
    IPage<TbCrmCustomer> createTime(@Param("type") String type, Page<TbCrmCustomer> page);

    IPage<TbCrmCustomer> selectPool(Page<TbCrmCustomer> page);

    List<TbCrmCustomer> selectNameAndId();

    List<TbCrmCustomer> selectAll();
}




